Tabela LBPServicePriceList

Definicja tabeli LBPServicePriceList

Name

LBPServicePriceList

Code

LBPServicePriceList

Comment

PL: Polaczenie uslugi w benefitplanie z cennikiem – ustalenie ceny dla uslugi
EN: Link between benefitplan's service and price list – assignement price for service in benefitplan


Lista kolumn tabeli LBPServicePriceList

Name

Code

PriceListID

PriceListID

LBenefitPlanServID

LBenefitPlanServID

PatientPartPercent

PatientPartPercent

PayerPartPercent

PayerPartPercent

OverLimit

OverLimit


Kolumna PriceListID tabeli LBPServicePriceList

Definicja kolumny PriceListID tabeli LBPServicePriceList

Name

PriceListID

Code

PriceListID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LBenefitPlanServID tabeli LBPServicePriceList

Definicja kolumny LBenefitPlanServID tabeli LBPServicePriceList

Name

LBenefitPlanServID

Code

LBenefitPlanServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientPartPercent tabeli LBPServicePriceList

Definicja kolumny PatientPartPercent tabeli LBPServicePriceList

Name

PatientPartPercent

Code

PatientPartPercent

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna PayerPartPercent tabeli LBPServicePriceList

Definicja kolumny PayerPartPercent tabeli LBPServicePriceList

Name

PayerPartPercent

Code

PayerPartPercent

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna OverLimit tabeli LBPServicePriceList

Definicja kolumny OverLimit tabeli LBPServicePriceList

Name

OverLimit

Code

OverLimit

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli LBPServicePriceList

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LBPServicePriceList

Definicja klucza Identifier_1 tabeli LBPServicePriceList

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment